﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Cinser.DBUtility
{
    public static class Common
    {
        public static string CombineConnectionString(string OraServerIp, string OraDbName, string OraUserName, string OraPassword, string OraPort = "1521")
        {
            return string.Format("Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST={0})(PORT={1})))"
                + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME={2})));User Id={3};Password={4}", OraServerIp, OraPort, OraDbName, OraUserName, OraPassword);
        }
    }
}
